Skip to main content

MatchType

The match type.

  • -1 - The values must be sorted in descending order. If the exact match is not found, the function will return the smallest value that is greater than the searched value.
  • 0 - The values can be sorted in any order. If the exact match is not found, the function will return the <em>#N/A</em> error.
  • 1 (or omitted) - The values must be sorted in ascending order. If the exact match is not found, the function will return the largest value that is less than the searched value.

Type​

Enumeration

Values​

  • "-1"
  • "0"
  • "1"